Date: Sep 5, 2024
Location: PHOENIX, AZ, US, 85004-3903
Company: APS
Our present and future success depends on the creative and dedicated people of our company who demonstrate the principles outlined in the APS Promise: Design for Tomorrow, Empower Each Other and Succeed Together.
Summary
In the Energy Analyst II/Senior role you will conduct analyses of large data sets to summarize market performance, ensure accuracy of market settlements and identify potential market design issues. Contribute to the team using data to identify operational opportunities and engage in strategic initiatives within the CAISO’s Western Energy Imbalance Market and emerging western energy markets. This role includes:
- Managing Settlement applications such as PowerCore (Power Settlements) and PCI including maintenance, troubleshooting, updates/enhancements working with vendors and technology support staff.
- Validating settlement statements using root cause analysis on discrepancies and manage any resulting disputes.
- Create reports, ad hoc analyses and data requests for internal and external stakeholders such as CAISO, the Arizona Corporation Commission and other regulatory entities.
May also include:
- Work Cross-functionally on market performance, stakeholder initiatives, and future Day-Ahead markets.
- Update existing processes to include changes in external sources such as CAISO’s Open Access Transmission Tariff, and Business Practice Manuals.
- Lead departmental and or external efforts by engaging stakeholders on market financial model revisions or initiatives that impact the business.
Minimum Requirements
Energy Analyst II
- BS degree in Business, Accounting or Finance and 2 years' related experience in financial analysis/reporting or data analytics.
- OR advanced degree in applied data analytics, data science or statistics and prior practical related work experience.
- Thorough knowledge of Microsoft Excel, Access, PowerPoint and Word.
Energy Analyst Senior
- BS degree in Business, Accounting or Finance and 3 years experience in accounting reconciliation, energy billing, or financial reporting; or an equivalent combination of education and experience.
- Knowledge of the applied use of energy accounting processes, related auditing techniques, and Generally Accepted Accounting Principles.
- Some positions may require experience working with the administration of energy contracts and the development, implementation and maintenance of financial reports and spreadsheets.
- A thorough knowledge of Microsoft Excel, Access, PowerPoint and Word.
- Some positions may require a general understanding of commodity trading, Risk Management, and options valuation as it relates to energy markets, resource generation and transmission system concepts.
Major Accountabilities
1) May confirm daily futures transactions with clearing broker and reconcile futures positions of commodity to counter-party statements and internal reporting system; calculate mark to market of open futures positions, monthly index prices and determine maintenance margin requirements as well as physical power, emission allowance, natural gas and paper transactions with brokers and appropriate counter-party; track confirmations on risk management system; research and resolve exceptions with trading/marketing and counter-party personnel; process invoices for commodity purchases, charge appropriate account numbers in order to bill counter-parties for sales; verify accounting records, payables from other utilities and prepare check requests within time periods specified in contracts; follow up with counter-party on past due payments; prepare various reports on results of system and trading activities; analyze daily reporting of operating results and maintain analysis of trading activities and strategies; review and verify broker commissions and submit requests for payment; prepare and maintain various margin and activity reports needed for monthly and daily reporting.
2) May maintain daily natural gas flow and price information for various gas strategies and books; reconcile gas flow data to counter-party statements and to internal reporting systems; review transfer pricing and classification issues for compliance with department guidelines and procedures; confirm gas daily market prices and monthly index prices to verify trades; confirm natural gas and financial transactions with brokers and appropriate counter-party.
3) May review coal contracts to coordinate developing monthly delivery schedules with counter-parties resulting from coal trades; confirm and reconcile daily trade transactions with clearing broker and coal traders; review contracts and ensure deliveries are made within contractual obligations; prepare invoices for sale agreements in accordance with contracts; research disputed charges with trading counter-party and brokers; reconcile coal settlements resulting from monthly purchase and sale transactions and premiums; prepare profit and loss statement.
4) May ensure the accurate and timely settlement of all transactions relating to the sale of transmission and ancillary services by analyzing and verifying energy, transmission usage and services charges, customer and system load data; review contracts to determine billing requirements for transmission settlements, apply rate schedules and billing guidelines and contract parameters; verify energy deviations and imbalance calculations and monitor return of energy; ensure that computerized billing programs are set up to accurately reflect contract provisions; interface with customers or transmission operations personnel to resolve inquiries and billing disputes associated with transmission settlement process; determine energy deviation balances, correct plant generation output, interconnected utility exchanges, interchange sales & purchases and transmission system losses; prepare detailed monthly reports of customer activity, account status and delinquencies; may prepare and distribute statistical information on energy usage, peak demand and metering data for use by other departments; provide data for monthly reports of customer activity, ACC, FERC and annual reports; may acquire, validate, estimate and edit data collected through interval data recording (IDR); may prepare and distribute customer meter data involving energy usage, peak demand, and load patterns used by organization; ensure completeness, statistical reliability and quality of IDR data; may apply industry methodologies and techniques to estimate missing IDR data; may serve as system administrator for software load data collection system.
5) May ensure revenue recovery from large power contract customers related to wholesale, retail pre-billing, industrial, interchange and transmission services; interpret and utilize contract agreements, market rate tariffs, and policies and procedures in producing monthly invoices related to the accounting of interchange pricing options and capacity treatment in power pool. May serve as billing agent for Special Electrical Districts in verifying meter reads, correcting consumption, verifying current rates, preparing and distributing invoices, performing cash management in receiving, collecting and accounting for payments, and balancing receipts; interfacing with customers or meter operations personnel to resolve inquiries, service problems and billing disputes.
6) May validate the accuracy of daily settlements resulting from transactions with the California Power Exchange and California Independent System Operator; research and resolve disputed data with ISO and traders; download price and settlement data and review pricing and classification issues for compliance with department guidelines and procedures; file and track disputes on erroneous charges; prepare analysis of load costs comparing actual costs from purchases and generation, including gas burn, transportation costs, and imbalance information; run system queries and provide various monthly reports on trading and settlement activities, analysis of counter party margin, book margin, etc.; conduct various reconciliation of report data, system logs, etc.; conduct analysis of trends and variances of purchases, mark to market data, option premium revenue and expenses; interface with Business Solutions group on developing automated reports and resolving system issues.
7) May ensure the accurate and timely invoicing of direct access and non-commodity customers, by analyzing and verifying meter data; reviewing contracts to determine billing requirements, applying rate schedules, billing guidelines and contract parameters; verifying deviations and imbalance calculations; ensuring that computerized billing programs are set up to accurately reflect contract provisions; interfacing with customers or transmission operations personnel to resolve inquiries and billing disputes associated with transmission settlement process; performing cash management receiving, collecting payments, and balancing receipts; analyzing vendor invoices for accuracy and authorizing payments for contractual agreements and services.
8) Works on problems of moderate scope and complexity where solutions are within identifiable parameters and involve analyzing and interpreting contract provisions, researching and reconciling invoices for settlements, authorizing payment of invoices and in resolving billing disputes with counter-parties/customers; exercising judgment within defined procedures, practices, government rules and regulations in the interpretation of rates structures, contract parameters and billing requirements. May coordinate the maintenance and enhancement of database systems used to bill customers, track status of agreements/contracts, sales and revenue forecasts, and other specialty data and coordinate the resolution of system issues.
Export Compliance / EEO Statement
This position may require access to and/or use of information subject to control under the Department of Energy's Part 810 Regulations (10 CFR Part 810), the Export Administration Regulations (EAR) (15 CFR Parts 730 through 774), or the International Traffic in Arms Regulations (ITAR) (22 CFR Chapter I, Subchapter M Part 120) (collectively, 'U.S. Export Control Laws'). Therefore, some positions may require applicants to be a U.S. person, which is defined as a U.S. Citizen, a U.S. Lawful Permanent Resident (i.e. 'Green Card Holder'), a Political Asylee, or a Refugee under the U.S. Export Control Laws. All applicants will be required to confirm their U.S. person or non-US person status. All information collected in this regard will only be used to ensure compliance with U.S. Export Control Laws, and will be used in full compliance with all applicable laws prohibiting discrimination on the basis of national origin and other factors. For positions at Palo Verde Nuclear Generating Stations (PVNGS) all openings will require applicants to be a U.S. person.
Pinnacle West Capital Corporation and its subsidiaries and affiliates ('Pinnacle West') maintain a continuing policy of nondiscrimination in employment. It is our policy to provide equal opportunity in all phases of the employment process and in compliance with applicable federal, state, and local laws and regulations. This policy of nondiscrimination shall include, but not be limited to, recruiting, hiring, promoting, compensating, reassigning, demoting, transferring, laying off, recalling, terminating employment, and training for all positions without regard to race, color, religion, disability, age, national origin, gender, gender identity, sexual orientation, marital status, protected veteran status, or any other classification or characteristic protected by law.
For more information on applicable equal employment regulations, please refer to EEO is the Law poster. Federal law requires all employers to verify the identity and employment eligibility of every person hired to work in the United States, refer to E-Verify poster. View the employee rights and responsibilities under the Family and Medical Leave Act (FMLA).
Arizona Public Service is a smoke free workplace.
Flex Role:
This position is not required to be performed at a specific APS facility as long as adequate technology and a solid ergonomic setup are present. Pending agreement with leadership, employees hired into this role will be able to choose where they prefer to perform their work, but the ultimate decision is the company's. Employees will have two options to choose from:
- APS office based: The employee prefers to work most of the time from an APS facility.
- Home based: The employee prefers to work most of the time from his/her home.
- Employees in Flex roles are required to reside in Arizona (or NM for Four Corners-based employees). Role types are subject to change based on business need.
Job Segment: Nuclear, Energy